Problem Note 57583: A deadlock or poor performance occurs in SAS® Workflow Services when you use Microsoft SQL Server for your SAS® Shared Services database
When you use Microsoft SQL Server for your SAS Shared Services database, you might see slow performance for services in the SAS® Web Infrastructure Platform. The problem might occur in SAS® solutions that use SAS Workflow Services to manage business processes, such as SAS® Enterprise GRC, SAS® Enterprise Case Management, and SAS® Model Risk Management.
By default, SQL Server sends text values to the server in Unicode format instead of the native data type defined in the database. The implicit data conversion performed by SQL Server might cause a performance problem. To work around the problem, add the following property to the SAS Shared Services JDBC DataSource:
sendStringParametersAsUnicode=false
After adding the property, you must restart SASServer1 for the change to take effect.
Operating System and Release Information
| SAS System | SAS Web Infrastructure Platform | z/OS | 9.3_M2 | 9.4_M3 | 9.3 TS1M2 | 9.4 TS1M3 |
| Microsoft® Windows® for x64 | 9.3_M2 | 9.4_M3 | 9.3 TS1M2 | 9.4 TS1M3 |
| 64-bit Enabled AIX | 9.3_M2 | 9.4_M3 | 9.3 TS1M2 | 9.4 TS1M3 |
| 64-bit Enabled Solaris | 9.3_M2 | 9.4_M3 | 9.3 TS1M2 | 9.4 TS1M3 |
| HP-UX IPF | 9.3_M2 | 9.4_M3 | 9.3 TS1M2 | 9.4 TS1M3 |
| Linux for x64 | 9.3_M2 | 9.4_M3 | 9.3 TS1M2 | 9.4 TS1M3 |
| Solaris for x64 | 9.3_M2 | 9.4_M3 | 9.3 TS1M2 | 9.4 TS1M3 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Specify the
sendStringParametersAsUnicode=false property for the SAS Shared Services JDBC DataSource.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2016-02-05 13:14:18 |
| Date Created: | 2016-02-04 17:19:30 |
